package kr.or.kosta.otr.persistence.companyreviewverify;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;

import kr.or.kosta.otr.vo.CompanyReviewVerifyVO;
import kr.or.kosta.otr.vo.TrueOrFalseVO;

public interface CompanyReviewVerifyDao {
	int writeCompanyReviewVerify(CompanyReviewVerifyVO vo)throws SQLException;
	void deleteCompanyVerify(int companyReviewVerifyId)throws SQLException;
	ArrayList<CompanyReviewVerifyVO> getOneCompanyReviewVerify(int companyReviewId)throws SQLException;
	ArrayList<TrueOrFalseVO> getCompanyReviewVerifyByCompanyId(int companyId)throws SQLException;
	int isExistCompanyReviewVerifyByCompanyId(int companyId)throws SQLException;
	ArrayList<TrueOrFalseVO> getCompanyReviewVerifyByUserId(String userId)throws SQLException;
	ArrayList<TrueOrFalseVO> getCompanyReviewVerifyByInterestReview(int reviewId)throws SQLException;
	int myCompanyReviewVerifyByUserId (String userId)throws SQLException;
	ArrayList<TrueOrFalseVO> getCompanyReviewVerifyByUserIdPage(HashMap<String, Object> map)throws SQLException;
	int getCompanyReviewVerifyByUserIdTotal (String userId)throws SQLException;
	ArrayList<TrueOrFalseVO> getCompanyReviewVerifyByCompanyIdPage(HashMap<String, Object> map)throws SQLException;
	int getCompanyReviewVerifyByCompanyIdTotal (int companyId)throws SQLException;
}
